﻿CREATE TABLE [dbo].[Intinerary]
(
	Id int NOT NULL CONSTRAINT PK_Intinerary PRIMARY KEY IDENTITY(1,1), 
	Reservation nvarchar(10) NOT NULL CONSTRAINT FK_Intinerary_Reservation REFERENCES Reservation(Code),
	Passenger int NOT NULL CONSTRAINT FK_Intinerary_Passenger REFERENCES Passenger(Id),
	[Status] int NOT NULL CONSTRAINT FK_Intinerary_IntineraryStatus REFERENCES IntineraryStatus(Id)
)